using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;

namespace YABlog.DAL
{
    public class CommentsDb
    {
        public CommentsDb()
        {
            
        }

        public DataTable GetCommentsByEntry(int id)
        {
            SqlParameter p = new SqlParameter("@id", id);
            return Functions.ExecuteParamerizedSelectCommand("GetCommentByEntry", new SqlParameter[] { p });
        }

        public bool AddComment(int bid, string name, string comment)
        {
            return Functions.ExecuteNonQuery("AddComment", new SqlParameter[]{new SqlParameter("@bid", bid), new SqlParameter("@name", name),
            new SqlParameter("@comment", comment), new SqlParameter("@date", DateTime.Now)  });
        }
    }
}
